﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
namespace TDT_Project.classes
{
    public class cls_hocky
    {
        string _HocKy_ID = "";

        public string HocKy_ID
        {
            get { return _HocKy_ID; }
            set { _HocKy_ID = value; }
        }
        string _TenHocKy = "";

        public string TenHocKy
        {
            get { return _TenHocKy; }
            set { _TenHocKy = value; }
        }

        public DataSet load_hocky_combo()
        {
            DataSet results = new DataSet();
            SqlConnection oConnection = new SqlConnection(cls_config.ConnectionString);
            SqlCommand oCommand = new SqlCommand("load_hocky_combo", oConnection);
            oCommand.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = oCommand;
            da.Fill(results);
            oConnection.Close();
            oConnection.Dispose();
            oConnection = null;
            return results;

        }
    }
}